﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="k.aspx.cs" Inherits="syc.Jidong.k" %>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:SCMConnectionString1 %>"
    DataSourceMode="DataSet"
    EnableCaching="True"
    CacheDuration="60"
    CacheExpirationPolicy="Sliding"   
    SelectCommand="SELECT SUM([数量]) AS 数量 
                    FROM [备品备件收支表] 
                    WHERE (([品名] = @品名) 
                            AND ([生产线] = @生产线)
                            )">
    <SelectParameters>
        <asp:QueryStringParameter Name="品名" QueryStringField="name" Type="String" />
        <asp:QueryStringParameter DefaultValue="1" Name="生产线" 
            QueryStringField="fenchang" Type="Int32" />
    </SelectParameters>
</asp:SqlDataSource>
